SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192583 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192583 [ RunTime:0.002916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983781,450484,243728,962217,671248,109438,582724,88813,754471,1032130,71678,623410,424322,610928,67229,454006,737031,623146,913212,612523,629242,356427,840212,794772,30411,78307,253956,962683,358969,7248,972229,661295,334526,907293,397879,711936,694194,308746,120105,515904,702594,572007,558063,690942,372717,929386,165860,156144,186016,1014669,693038,326605,830309,640820,61844,941448,275959,100106,637062,4234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]