SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106824 LIMIT 1 [ RunTime:0.000975s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106824 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398012,938112,792436,863814,703199,854291,954372,216394,185160,265315,507412,3694,825038,61321,583038,871016,12188,217255,87166,248174,412017,356695,87037,294656,630201,530846,499978,935145,593758,259577,597549,448956,949113,870209,315375,339581,909223,87443,673477,1029016,99318,550204,472407,810094,185874,257598,90786,739263,441778,861921,592814,1041812,874154,914501,883380,602157,840329,443908,633267,310065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106824 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106824 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]