SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575436 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575436 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588788,14018,399002,969786,778967,49733,495948,241430,357960,669184,1008786,447479,788699,1042792,429390,16027,838450,371513,645909,297374,227139,39361,623776,370685,529530,105004,633930,81347,434638,323174,868918,20613,119122,1035789,12750,538457,767815,568647,560810,326724,231116,485746,636664,457206,843292,1045359,630675,462792,456760,654335,640166,316522,606276,58840,1007491,261138,282668,171690,537514,518360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]