SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003909s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591513 LIMIT 1 [ RunTime:0.003645s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591513 [ RunTime:0.004806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191833,667633,641895,824402,53413,320692,377432,663956,802002,746238,391724,323511,889836,400451,419422,646468,460246,935936,717989,131181,184087,905359,201650,13957,401246,509707,588520,553716,430530,201141,981953,254106,197903,547957,376788,905694,532824,172877,1000414,260269,619172,553984,780410,231106,800546,470351,1000229,538942,673425,957806,790178,739911,591142,946240,1007306,447594,656828,695595,488203,1042010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004868s ]