SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021589 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021589 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22183,52949,568841,120546,936736,1006744,777168,988588,279045,440705,986301,81541,457206,954093,913659,280742,541104,544209,287177,552748,7327,135388,48899,124863,527062,128543,855188,999683,1032397,367558,40885,781849,1011422,247930,753615,943582,937087,258475,627649,1012218,681080,622169,810744,656084,221220,1041109,193223,670779,237273,139906,384268,667848,863455,257150,56689,144455,311956,964174,1000482,879592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]