SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030175 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030175 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648777,130540,579635,418722,776868,914031,581362,838987,410843,328664,537082,379323,190550,441067,638905,455458,880718,847772,247691,294820,991867,140249,16315,1043694,995328,837054,783687,126364,203782,508134,10267,626908,777122,845362,192192,761952,920568,233320,609522,720270,356992,196912,489396,774774,932230,987152,752913,154559,987487,802520,974164,1030574,427865,973238,171508,458750,907209,474698,142112,567703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001755s ]