SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180413 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180413 [ RunTime:0.003710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035736,684874,746968,799923,256113,725621,10366,398366,222457,880012,139288,961882,447175,193291,169273,426809,254379,862875,305246,934299,855892,134348,966862,273818,333726,587506,765633,476941,290501,51031,645104,661461,792862,671793,221279,224306,503309,972120,261071,1003374,268562,422370,42116,695719,341495,119266,178025,793202,934041,856542,549740,877905,683150,13610,1028449,564016,241175,762836,105817,167044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]