SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54183 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54183 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28159,287915,686505,394541,112169,684221,21306,869841,773108,221517,780686,567134,324882,262343,979868,507274,45677,261028,222894,122688,771944,732554,297551,988554,141883,110429,5998,961856,629405,437576,1039302,98067,567953,339450,332707,69103,206357,810620,430470,440109,1038653,659267,314356,1033300,866442,793510,495400,841770,593040,560850,70113,791747,511668,86536,353014,720062,245676,921220,312442,267072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]