SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534098 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534098 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584370,430572,226079,620120,961541,938466,306298,251444,143985,277729,881287,122597,190740,222330,999158,196259,175767,234872,161663,559450,35099,889539,705340,818937,56621,906064,20755,789497,258310,814406,288593,140340,437941,74644,901668,85886,170751,584466,803889,373577,882301,395074,841306,150950,213318,667296,195706,932051,199843,379753,83015,749838,291383,559212,53258,487629,470039,797397,457381,589585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]