SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 817448 LIMIT 1 [ RunTime:0.001469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 817448 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304982,874847,1008018,789240,539043,484144,925735,890992,825929,22758,34953,824149,844701,943760,853293,408386,278428,551585,316681,791665,338708,411088,177856,359341,231562,915136,131602,351928,1015164,668469,657632,376347,237319,718981,1010561,687991,68103,235799,57552,24015,277426,1022540,639153,473023,287439,645786,641328,401845,690451,450363,317549,194238,450035,293301,1004473,593787,594445,363878,379219,318523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 817448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 817448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]