SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97448 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97448 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423374,382625,503468,1020217,440189,920412,145988,114231,189401,712928,369317,467459,65983,874977,757104,198978,479299,979680,295035,526181,366574,920014,21975,561572,756526,182636,371565,291739,537772,357661,255655,59620,959094,773370,583874,375398,985224,908713,343006,738700,510970,862252,44617,927622,798322,435666,767587,379123,111025,538190,94697,957226,231237,976344,1016696,640566,630982,333151,296594,751787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]