SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535309 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535309 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298970,774076,933980,519341,972666,697113,826491,590920,379627,702223,384467,449939,662099,478188,471475,648239,85278,938735,568856,134129,755304,255633,609367,339525,608806,262569,822502,732580,66222,839992,558112,600392,563089,701143,797366,191030,930210,318521,686522,390672,654669,279693,264035,573754,294832,294284,531066,860180,1029325,831123,503522,762854,243033,612186,1034266,41891,756432,843049,150516,253535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]