SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020299 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020299 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898492,245394,961639,251147,258701,536940,890634,533650,606568,342381,842335,183032,1018114,757530,855177,609490,758940,46385,6656,590671,910163,173583,438497,1015586,234183,53697,982576,383515,642008,419763,908547,252556,368807,521423,871996,392972,307454,254226,884224,978376,273566,111271,580612,727113,472741,827793,812131,961420,290191,37335,188727,567569,425260,1046541,235980,31516,800516,992055,784132,281347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001261s ]