SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467211 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467211 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19474,841199,443629,943378,378106,1036863,503000,42641,712150,1016205,764491,532590,600903,1028169,168626,362453,920280,1037381,959987,1040,436625,438285,672425,991633,993307,685554,394828,329716,4931,429985,936777,943162,370155,174784,731907,424074,840841,104897,691448,708773,444120,78849,66750,825942,440439,584087,352266,823418,967918,1031173,419506,267954,520596,294213,250055,682700,179845,614277,782616,217089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]