SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531533 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531533 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553710,960972,477978,75800,307834,388581,746852,136036,739055,179014,85962,63982,904414,544805,716940,883419,627145,671744,830954,525649,443693,744797,20437,474126,467750,497040,308967,172927,409543,722122,819743,792730,467580,425784,414693,382122,324479,1882,733107,411201,500308,530748,827766,368842,196575,186793,1023724,40007,818434,104512,332829,287487,898060,597849,155109,537197,494046,547962,979210,151164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]