SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040904 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040904 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407364,143596,302917,48896,803542,1032635,730803,935963,626399,883543,589014,963517,650357,126606,602302,769678,44979,412698,831431,875969,248198,587000,731080,801104,241043,579557,50860,781954,29232,702321,420122,869094,938713,718531,336520,104528,89832,243621,379600,116151,986361,171289,432632,16159,764070,432611,677538,898508,47218,323529,419481,259443,402676,150738,964927,906361,427884,264844,608672,78741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]