SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 928101 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 928101 [ RunTime:0.004214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941086,1035169,574728,316011,943316,804822,1002330,1048782,915735,112923,789278,969329,130183,76125,257769,232683,441179,597609,350412,430244,782453,421493,330060,12968,349616,314091,661787,423379,797309,1010010,666534,1039721,20189,916179,373498,299000,164494,158001,282593,652742,165735,335654,558061,794382,286285,233528,278043,981232,649048,788821,1031411,815211,188048,573024,971952,509394,924271,720984,312924,532866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 928101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 928101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]