SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512005 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512005 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323363,390665,554699,747310,504373,728612,733713,723131,823636,674066,128125,422897,788635,143234,732713,258793,472322,555441,38359,702657,1031489,218719,749490,534241,1041521,461765,893939,395198,1045843,509872,680520,273716,284762,162714,442053,499106,114837,497094,126380,126801,263773,355829,692622,991967,452106,779455,847206,29583,676526,288757,53010,654947,940527,221206,746218,348842,370039,298742,360289,866586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]