SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421588 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421588 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399610,553122,1021574,207056,380733,875670,361268,635697,30059,645069,416548,867914,177085,813309,1029285,1001262,166923,193712,236944,332588,118797,104610,943327,23252,378362,900702,345665,865707,625745,569346,498473,680821,857952,257342,319242,875610,457178,894320,512034,244637,267458,403841,88344,154777,567322,887042,969575,423117,605399,699180,171473,452660,938131,864466,1022846,228871,446552,224153,226852,519945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]