SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037976 LIMIT 1 [ RunTime:0.003379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037976 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317974,973687,431853,620068,216414,791154,87279,8554,513402,1043319,391832,177330,579536,228242,613306,222907,840469,751708,329294,945472,700646,111670,495630,568532,491177,98315,27381,67924,840794,722881,731031,826185,896418,841771,164748,965317,15265,535931,995519,518159,953614,534375,798269,263623,488113,392239,179117,562451,70212,334666,88712,684087,232220,907180,440192,345937,978341,937838,384004,933117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]