SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351283 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351283 [ RunTime:0.002705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676572,952379,110282,203938,124889,54729,886808,242792,52945,74444,935848,1037196,319980,769503,539052,781107,953539,457385,733601,390253,397213,361324,137251,644156,807772,986305,131953,537790,160188,223163,193906,529977,157193,839883,66496,924292,798582,132480,11781,235942,160657,402957,737796,593039,447952,828242,889965,772783,334544,419892,440145,536393,554602,534624,876283,839599,235927,912736,308485,873588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]