SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448623 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448623 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799287,804615,831032,860537,1032063,273348,63587,541943,166102,729900,810045,546203,923352,745217,259439,385493,44224,178270,831459,635,155998,58479,443535,1037440,185231,212775,319863,1039907,655231,80838,367228,367625,390041,332360,60126,384254,985430,774856,306496,438353,467288,527402,802562,471221,141821,90824,1000481,318321,329859,667549,56588,384813,856588,120298,437067,323581,1036449,886370,315453,734270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]