SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203488 LIMIT 1 [ RunTime:0.000598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203488 [ RunTime:0.003982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166699,700149,247961,427766,75722,73456,33970,152120,1014108,218707,561608,145368,322627,224756,643005,105255,765523,585366,104469,663087,146295,465601,232320,73849,404470,32079,487914,641852,898440,816844,531943,8913,950141,204694,524144,798232,657147,1016385,671005,48290,971011,772967,1002611,505336,188181,24727,1036746,984105,948561,515065,653180,31493,996065,362228,175784,869344,831107,270924,896791,289456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]