SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034043 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034043 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921819,947575,940897,373668,625028,629065,105778,464455,605721,148185,130345,559269,861864,1016986,309990,698120,353826,290103,77658,719461,95593,1003578,315694,212328,744315,799954,781909,541921,974524,578277,866614,640906,1032053,35514,1045262,281127,740001,756673,315695,332391,276603,617800,127841,657293,20977,636702,551504,885613,862601,714397,863322,779408,185780,854639,321156,194380,958409,542080,887048,524935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000936s ]