SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50156 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50156 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674953,1038917,688546,853981,512029,494493,218629,839870,496464,52132,230218,500399,724943,11416,921744,52809,398435,921645,189135,338532,321251,519330,943066,869131,483994,773316,1016323,1029525,5150,827048,264107,439730,448253,124808,798458,4047,127934,431903,1016529,663594,806031,570312,920216,333756,1018658,954707,979199,718034,1035185,391387,154829,221795,43664,490651,781049,146758,947792,776533,661142,522838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]