SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804476 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804476 [ RunTime:0.004465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121353,375057,725905,391198,792904,826414,599974,74079,705467,310091,907716,857295,306768,1034405,663501,591490,81690,626262,585429,12631,817663,535704,8316,620515,348794,400870,588185,1024422,174607,885652,238875,577097,680159,467649,935146,320384,899002,226667,482879,574416,493688,735044,192025,717485,517467,69177,304952,992155,921883,851419,1036635,851322,828842,252438,971835,220182,152889,855989,291709,214163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]