SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533440 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533440 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356319,180283,261525,1014945,142059,302323,831409,485215,360959,549265,749767,230569,665342,631805,416175,347074,41115,696192,783520,385165,40684,807268,939108,411475,537444,396538,561965,813585,674877,1005705,315420,879552,950676,418045,461369,860404,447555,476336,487897,49400,407083,229342,76388,78340,158039,607033,67457,337513,585417,625679,387138,62464,520664,426566,1033253,781880,612440,665147,610063,460375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]