SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403558 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403558 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680200,953380,5216,402611,778136,854751,697954,380477,28902,757510,678275,838483,139633,817590,406452,229509,67361,441020,690954,810898,912420,341922,886395,673820,465564,936490,69186,884493,331759,319540,979997,253607,1000482,719190,414804,916739,440431,183968,840043,776860,88048,148033,859006,484767,68894,483914,554121,1028482,17020,440000,14094,979584,539778,450549,119815,857365,189724,690400,499257,968199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]