SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508916 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508916 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363712,603560,657775,534807,485377,547081,943211,468314,465341,100547,1038660,466390,742223,695578,1010793,560213,869554,445183,460617,443330,288503,500991,493593,979172,737465,641133,75872,921703,953688,116974,189063,348343,665473,882946,267537,726189,719545,321771,981675,594587,87633,1001864,256293,650599,839193,471475,330381,976698,597306,200394,243542,259318,724990,495388,836040,367280,93875,958756,698263,548937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]