SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426750 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426750 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825837,1041600,219020,286973,713489,673261,69378,530923,932457,476722,13621,627699,96737,290009,4210,45313,244662,422114,543110,1000783,526675,128377,590433,483006,897677,44053,651582,471029,4176,213582,53152,377585,519063,107449,941223,897870,273432,666155,314079,584533,544098,464691,1027403,294577,927276,936926,204024,397719,156400,135240,480556,715428,551394,586662,856826,901768,893431,73048,1018372,728658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]