SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406178 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406178 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31090,872586,391279,1004390,439979,30347,48135,141232,532009,564084,1020309,649149,919869,247326,441078,388915,255050,713428,319570,602141,805006,830298,513823,1682,753094,833418,668118,960420,333543,847324,349799,791757,48080,874791,1014547,957999,886594,171624,166339,273911,20002,931319,710953,191545,633957,284565,493715,932926,579724,15368,643949,31224,521242,331145,600595,773335,1048868,517084,221950,619094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]