SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800519 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800519 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476092,105585,252019,647051,163813,819052,977877,289333,487717,753840,1039283,498330,989974,358289,239556,208759,270717,58544,293108,779473,79846,135603,392593,52953,652497,89774,212213,520069,902860,214503,608601,815945,496877,652056,290522,772355,482126,159690,417079,813927,363090,545554,1047887,330209,914009,737779,910512,304459,167535,798700,139571,494104,295669,447753,442619,978778,625548,768981,207417,165899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]