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` = 145327 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145327 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866106,883682,104294,97216,626815,179979,976564,1034893,25563,257860,1040637,423739,709407,1044542,910097,428819,55347,665490,738933,215436,528063,345934,871875,598734,1040922,936526,156457,15713,526724,125700,253650,276814,180734,480761,662178,541700,804514,107632,6514,30220,545340,499601,983026,394085,402482,393634,353127,630087,1012505,590254,505149,269229,661599,610067,171077,537949,262013,917997,233043,998971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]