SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495212 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495212 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011179,679211,330507,510357,686384,231836,400694,902547,799689,55522,388323,110272,262674,409998,907406,514780,375440,8180,23482,872232,464708,360897,495343,248433,747235,638389,541325,611834,95846,859107,167125,622113,724121,839017,813326,94390,189829,564144,981934,263991,19823,918202,38962,838096,65641,691387,78899,930666,634247,126462,105583,46930,281782,639979,90178,897270,147883,526299,602782,567492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]