SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421571 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421571 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119660,311849,527571,189461,936084,613999,830147,915100,701655,660165,614452,869927,201166,683378,360208,291289,52312,321827,160612,55608,873916,318345,1040261,629687,614577,551046,186850,628795,929519,129263,684767,486262,1040387,359458,328463,892109,1016663,518746,89350,83645,596732,815367,917238,6513,1044560,956417,368586,377938,17456,88453,842699,421697,58073,627738,683758,313422,981993,276697,84653,9449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]