SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517723 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517723 [ RunTime:0.008381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378517,296920,116676,964243,347434,100103,884205,867280,756088,345218,852672,495599,374921,249404,225739,864288,7946,266700,54228,916097,473438,547267,95512,409334,265728,167678,622670,748235,474908,733720,743255,516378,40327,101698,751312,891978,594969,727865,63960,176697,294277,618740,796165,434139,189055,211547,330357,21381,870562,430051,33485,609788,225363,852310,670019,163239,261552,857443,377524,464073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001662s ]