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` = 1004994 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004994 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396647,156035,418529,214764,186389,50349,882337,281213,606146,238697,367306,402521,883565,1021144,477560,160837,1046678,309436,56480,33421,79528,837676,726745,81334,222851,230732,888004,580621,762490,792955,283050,482755,802695,984181,395862,597086,258966,114488,738653,490838,285978,395623,429794,868302,84565,71799,139266,876061,283171,498837,305241,717630,532861,492215,10614,573621,984777,676208,638004,296855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]