SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023662 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023662 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427363,225129,546155,666994,113615,786365,180080,723507,221073,1004165,241548,499191,45792,689469,376620,301825,791633,1012937,811181,927309,836921,686198,875579,497578,815271,410910,942618,503031,712304,520383,882070,326777,940395,867298,797475,968511,701523,593788,928714,749727,803779,191233,309447,623482,1039881,645337,1001724,106241,522679,298077,574500,84353,905315,416994,406414,86280,38043,945533,29287,651797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]