SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514922 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514922 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433985,365388,30509,925224,151605,569910,1013388,737070,696843,621221,635448,656067,203221,501896,436133,721721,233918,10232,756719,172789,257480,773868,567350,600535,224336,304879,113780,65258,560521,815642,232846,7956,404555,814979,167652,842438,133215,485375,770640,924232,831425,70151,629242,928694,574754,813499,129984,272544,970119,281658,308254,364929,449963,1001691,86887,153115,523045,361646,469694,484388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]