SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403697 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403697 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515217,321502,419361,242562,153127,294109,66949,954172,850017,512577,333100,60236,419394,889525,545991,262492,132752,861048,697411,257775,712739,1006347,713081,314807,587146,416962,949225,639039,234789,733219,684065,974443,68231,991390,283271,455246,356955,44220,889372,989220,858435,512177,411528,145497,854726,555537,245854,303627,137496,898144,146820,353448,499377,219306,461091,1031992,303827,192228,127809,274116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]