SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517524 LIMIT 1 [ RunTime:0.000534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517524 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915074,213909,149470,403081,419631,448357,241715,287706,971894,650565,388222,933657,188484,977364,445442,89758,178940,726428,64058,971780,414098,1024228,302062,240243,13194,439880,932752,753405,425799,390465,1002470,619061,694506,647639,21658,911266,82684,591642,313745,432272,439018,74675,155040,284909,835569,842802,135122,45825,322552,797998,891902,967476,117480,286760,904470,608088,250498,896405,629338,614543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001752s ]