SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019820 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019820 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102471,493460,105231,1038043,836520,1000380,87124,1020345,511406,400849,210188,90089,556813,819316,791621,259178,273231,550001,919696,577880,964210,207340,235104,292860,721106,226061,309521,128204,384953,986589,217485,333024,699469,3131,161230,890155,482123,476515,326352,435799,110231,1045185,76587,685608,862344,252018,846651,369267,106933,12419,475205,445069,211579,165241,991556,136911,706206,982851,843646,707799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]