SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514871 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514871 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488744,565880,906181,718140,995822,1034579,436038,173949,877034,870563,569526,709432,577033,986467,327579,469021,950333,597912,425436,239753,284967,540930,478226,285152,37065,370047,194662,816742,331710,606408,178427,51035,554099,782948,578177,577116,672459,930716,305822,258922,334858,280043,892404,415651,706985,883659,478020,726379,1046948,351019,843735,878496,1010844,801401,972151,550269,822649,480751,220199,260806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]