SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711576 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711576 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550686,403425,523528,306765,555635,390874,401045,330015,90510,780566,910504,992568,230325,638703,991439,517377,519764,840160,147860,225425,993154,333046,350904,268992,133642,33544,598099,116415,674410,47141,601777,973810,186462,387165,960928,975672,24519,495463,126964,298678,530483,382511,488613,527277,767692,570076,916474,53455,947499,171640,552835,694189,960157,911251,13627,1026581,998509,164486,386412,761307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]