SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381712 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381712 [ RunTime:0.002639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505461,292513,19549,681393,544727,812352,608788,892078,277169,457691,538577,735104,607610,449237,776062,77553,803446,490039,26941,523611,874786,659066,59096,70108,1037387,473160,633033,778206,147906,174447,764284,611136,966708,753213,79586,315638,534202,310267,212091,29140,591800,136344,778290,100900,254758,8578,414382,836528,808672,895585,103401,288910,690012,100117,122262,350175,978464,529153,399953,159267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001581s ]