SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387518 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387518 [ RunTime:0.003361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570796,724447,692117,886073,218398,652159,915183,484672,354120,329158,528821,160263,501209,572138,280266,505544,650725,60338,323327,457001,289454,141388,202194,279672,562573,512272,719648,262315,651678,255763,424391,170146,887856,86006,34680,389510,869964,106536,444647,11450,951967,742131,557765,109082,898673,510412,481035,698407,95092,576550,885630,994514,966912,40699,130503,996689,743803,43482,775494,308236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000927s ]