SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 745403 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 745403 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593882,575757,345160,868733,79651,1037041,936655,393230,1027279,378651,129951,736071,242920,703154,93951,320353,228942,772940,755001,101268,944272,298683,584370,457911,712457,197493,937423,428713,239318,682739,474363,256638,175110,1023361,599341,727831,140130,432835,728427,1038263,519893,263805,784887,248566,104063,635129,887067,939113,846720,406029,896994,205314,1000393,762540,495660,687440,156946,78005,766477,438870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 745403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 745403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]