SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426442 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426442 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856111,165976,906594,1022091,401560,747570,312967,234740,480539,734454,490930,827058,908724,612816,426758,233752,687594,150881,768131,339859,112563,676882,573452,91011,1047311,428594,828075,863967,555628,124316,353139,108274,558808,778925,2555,654476,284098,509106,566076,179182,331646,863940,909154,1007759,451457,595602,601750,596742,36822,396778,428515,260498,1033335,414577,178416,769612,788370,701712,864727,118822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]