SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114810 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114810 [ RunTime:0.002419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500947,696348,263923,349995,346335,967073,288842,1609,445557,551886,881075,863282,535265,687528,634002,782687,919584,356899,982335,1032144,457811,10221,570666,949656,1022937,150115,85527,159422,913289,581204,630611,49083,298244,787830,19697,153658,978439,628763,124094,171645,303410,966958,831389,527126,876440,641289,408442,527939,457489,458159,254490,280764,950536,942632,461312,469708,307100,618196,293465,1028355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003736s ]