SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424388 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424388 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112455,549822,426329,561923,576886,963397,635945,344674,415646,23013,442667,804408,410334,524722,961345,756650,401678,509619,827736,977068,883834,1031561,37805,153227,890508,974411,767386,593856,4164,939827,509967,920587,301774,914175,361667,863970,453744,985265,561952,219142,881630,989274,471290,349786,959173,607702,806922,101336,630035,600132,27337,675175,799474,553327,968094,454329,739406,633853,311803,442998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]