SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464291 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464291 [ RunTime:0.005436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468958,594475,223404,971316,918418,5556,846466,605668,209837,821570,424897,735705,349840,771745,599372,123057,884426,176969,396690,436318,386324,314144,926671,155217,169580,195649,210983,765259,569682,215137,965541,333189,857787,256829,985869,444467,971659,653124,264027,527900,950982,270713,803687,601938,924774,112456,839238,882781,255170,351362,619768,292388,985264,11726,873700,876949,966954,67493,207048,445599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]