SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52403 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52403 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203441,735733,589755,215096,32253,932151,992121,89337,272951,115935,84838,426839,438263,907296,240164,925306,917813,760040,769362,427519,609527,293965,890539,803358,351788,32022,781077,509624,173468,462074,688864,549447,142210,466883,640249,861041,65135,137520,814718,357417,11018,960099,562441,946606,759975,185420,464156,592400,1014254,881238,281756,16692,563322,554714,201876,278813,463581,593946,847969,305719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]