SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527063 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527063 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326975,525974,861100,1045470,560735,338293,712944,46481,177028,118509,96834,828748,245662,761324,16870,307039,811186,471989,1020037,445442,970991,379696,908806,249149,110071,519852,884352,814925,798762,6615,224160,148997,202203,946008,259788,247424,544213,930516,898462,139913,529417,730753,611350,512773,314849,811832,835988,748866,846882,467273,126454,868242,1029236,89253,201730,239431,193715,596619,53068,306536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]