SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001932s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313688 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313688 [ RunTime:0.004944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241894,649938,705135,294642,883374,1019003,910866,364421,989355,698893,747475,605766,86703,586990,171276,630727,185914,498388,152925,1038240,111646,278472,962269,332653,175524,34786,621953,432884,1047144,469180,592910,605044,260013,911557,687175,646085,487878,51361,322265,943792,711051,497491,928044,581798,593266,88237,763317,557557,917606,288256,993084,403755,391612,330119,529147,914243,218188,409063,477720,786226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001734s ]