SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422381 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422381 [ RunTime:0.004051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719960,993007,121325,651883,1019000,1011934,568623,800282,609255,406167,843484,473920,285307,307272,994559,247232,657298,31763,870105,575864,97992,149178,929538,174653,473075,456397,885502,987781,1036800,645797,829761,27082,251575,619090,878662,134319,905332,998812,35688,394456,711478,387612,670547,239907,392903,130263,1025531,981148,448324,1042687,174914,422236,824306,409464,112510,710347,825963,775583,98285,744643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]