SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001884s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546728 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546728 [ RunTime:0.002163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595160,715251,1013680,16970,496034,618154,22621,954863,968876,1025175,619495,894273,863460,350964,511471,298622,538990,529355,760676,719726,27812,64658,824588,306662,832020,51129,75668,223432,175858,235950,853133,988998,898237,430674,964352,110914,1041282,845647,766543,209153,936436,438362,355494,947331,878144,62512,396803,291150,336909,219224,273437,349034,457032,735626,672719,559740,33710,269265,989133,224009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]