SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201911 LIMIT 1 [ RunTime:0.001015s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201911 [ RunTime:0.003650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836983,605004,845205,882751,679189,222501,846151,130669,733746,238291,336501,723221,580802,433266,126950,328047,728917,486268,205645,1044370,950777,637719,820656,205681,50508,76887,719730,352061,671843,701418,890474,521230,396190,44677,643205,894464,1019679,1012228,803940,574349,712746,719199,416527,476154,274506,1025878,348006,522165,1036361,221195,900822,1022162,12852,838836,90124,1007359,970783,893036,386202,79833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001555s ]