SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507470 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507470 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62714,866563,139127,913643,714598,536223,547217,215740,493063,1019538,793713,458454,56994,886984,445641,626596,731536,289815,943233,860164,258585,553188,68423,936719,985593,1001320,169211,12253,333180,500627,566999,262937,449649,93476,244240,306250,105591,493279,779902,948842,140244,533490,458352,501976,298355,63566,722343,312766,840853,848152,804510,705235,196954,648245,1047281,771635,390134,252394,287533,941548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]