SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015974 LIMIT 1 [ RunTime:0.000901s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015974 [ RunTime:0.004264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201432,749851,491522,752097,281605,459315,184860,20245,724224,227862,561523,431119,717427,711303,548356,412223,224111,10913,992315,197847,202987,190838,690495,769793,764236,956506,759061,513534,577238,828542,425373,41941,639646,992388,817007,568190,1016630,529638,901171,36144,450703,557761,892616,766072,500186,959291,965503,574439,565889,938619,368600,717579,175334,166665,157787,900864,6517,514636,577188,468560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]