SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 624710 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 624710 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499010,416605,709162,801551,879611,569325,909359,1022594,379262,202513,603565,570138,42033,100701,764412,828992,205650,842385,101244,724104,518097,231634,802109,777866,449084,264105,795589,645380,207332,1000527,375103,633780,97903,1796,4814,236122,470782,790577,931803,169699,614575,968680,442391,86702,916333,348797,508463,430570,1138,916135,432707,846302,68512,350106,906826,811022,478280,49630,89014,910334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 624710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 624710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]