SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509276 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509276 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406269,812033,788064,296771,1033615,957813,697727,295471,394436,139613,895546,230467,175219,744565,245912,132913,30760,705439,823961,943868,461766,733761,200285,585896,411239,311280,700796,962352,537570,374608,746027,206024,917615,544138,752492,437265,199793,1001108,673853,530706,972433,84657,1015782,807669,66377,1026369,114295,715069,798025,271232,177159,156320,666218,70007,675453,612414,353642,25646,960762,967197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]