SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10623 LIMIT 1 [ RunTime:0.003661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10623 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030213,785577,737560,28944,403276,684921,1013478,713105,130011,437923,1047811,999328,414198,1042959,1044073,50986,513226,322569,1038135,759401,682808,906885,29696,1046472,333228,468932,572837,356633,409125,209927,621407,772338,911221,45678,185537,373604,958064,327687,935180,629736,347031,1032738,641104,1008090,513396,603224,536614,1011903,823996,383514,267130,73375,161285,307285,958790,135370,913017,558823,852746,1033256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]